CREATE EXTENSION IF NOT EXISTS pg_trgm;
CREATE INDEX IF NOT EXISTS idx_gin_ocr_search_text ON ocr_search USING gin (text gin_trgm_ops);

diff --git a/server/src/utils/database.ts b/server/src/utils/database.ts
index 8c05543..d4df8ae 100644
--- a/server/src/utils/database.ts
+++ b/server/src/utils/database.ts
@@ -391,7 +391,7 @@ export function searchAssetBuilder(kysely: Kysely<DB>, options: AssetSearchBuild
     .$if(!!options.ocr, (qb) =>
       qb
         .innerJoin('ocr_search', 'asset.id', 'ocr_search.assetId')
-        .where(() => sql`f_unaccent(ocr_search.text) %>> f_unaccent(${options.ocr!})`),
+        .where(sql`f_unaccent(ocr_search.text)`, 'ilike', sql`'%' || f_unaccent(${options.ocr!}) || '%'`),
     )
     .$if(!!options.type, (qb) => qb.where('asset.type', '=', options.type!))
     .$if(options.isFavorite !== undefined, (qb) => qb.where('asset.isFavorite', '=', options.isFavorite!))